﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true"
    CodeFile="StockList.aspx.cs" Inherits="ServicesSheet_StockList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Titile" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" runat="Server">
    <infolight:webdatasource id="wdsServices_OfficeSupplies_StockSId" runat="server"
        cachedataset="True" selectalias="Usasdb" selectcommand="SELECT dbo.Services_SV_Supplies.SId, dbo.Services_SV_Supplies.SName, &#13;&#10;      dbo.Services_SV_Supplies_SV_Type.TName, &#13;&#10;      SUM(dbo.Services_OfficeSupplies_Stock.StockCount) AS SSCount, &#13;&#10;      dbo.Services_SV_Supplies.SType,&#13;&#10;      dbo.Services_SV_Supplies.Remark&#13;&#10;FROM dbo.Services_SV_Supplies INNER JOIN&#13;&#10;      dbo.Services_SV_Supplies_SV_Type ON &#13;&#10;      dbo.Services_SV_Supplies.TypeId = dbo.Services_SV_Supplies_SV_Type.TId LEFT OUTER&#13;&#10;       JOIN&#13;&#10;      dbo.Services_OfficeSupplies_Stock ON &#13;&#10;      dbo.Services_SV_Supplies.SId = dbo.Services_OfficeSupplies_Stock.SId&#13;&#10;GROUP BY dbo.Services_SV_Supplies.SId, dbo.Services_SV_Supplies.SName, &#13;&#10;      dbo.Services_SV_Supplies_SV_Type.TName, dbo.Services_SV_Supplies.SType,dbo.Services_SV_Supplies.Remark">
    </infolight:webdatasource>
    <infolight:webdatasource id="wdsServices_SV_Supplies_SV_Type" runat="server" cachedataset="True"
        selectalias="Usasdb" selectcommand="select Services_SV_Supplies_SV_Type.TId,Services_SV_Supplies_SV_Type.TName from Services_SV_Supplies_SV_Type &#13;&#10;Order by Services_SV_Supplies_SV_Type.TId">
    </infolight:webdatasource>
    <infolight:webnavigator id="WebNavigator1" runat="server" bindingobject="wgvMaster"
        statusstrip="WebStatusStrip1" width="100%" cssclass="NavigatorBar" ctlheight="25">
        <navcontrols>
                <InfoLight:ControlItem ControlName="Query" ControlText="琩高" ControlType="Image" ControlVisible="True"
                    DisenableImageUrl="../image/uipics/query3.gif" ImageUrl="../image/uipics/query.gif"
                    MouseOverImageUrl="../image/uipics/query2.gif" Size="25" />
                <InfoLight:ControlItem ControlName="Export" ControlType="Image" ControlVisible="True"
                    DisenableImageUrl="../Image/UIPics/Export3.gif" ImageUrl="../Image/UIPics/Export.gif"
                    MouseOverImageUrl="../Image/UIPics/Export2.gif" Size="25" />
            </navcontrols>
        <navstates>
                <InfoLight:WebNavigatorStateItem StateText="Initial" />
                <InfoLight:WebNavigatorStateItem StateText="Browsed" />
                <InfoLight:WebNavigatorStateItem StateText="Inserting" />
                <InfoLight:WebNavigatorStateItem StateText="Editing" />
                <InfoLight:WebNavigatorStateItem StateText="Applying" />
                <InfoLight:WebNavigatorStateItem StateText="Changing" />
                <InfoLight:WebNavigatorStateItem StateText="Querying" />
                <InfoLight:WebNavigatorStateItem StateText="Printing" />
            </navstates>
    </infolight:webnavigator>
    <table cellpadding="0" cellspacing="5" class="TbSearch">
        <tr>
            <td style="width: 100px">
                <asp:Label ID="Label1" runat="server" Text="办公品名称：" Width="75px"></asp:Label>
            </td>
            <td>
                <infolight:webrefval id="QuerySId" runat="server" datasourceid="wdsServices_OfficeSupplies_StockSId"
                    datatextfield="SName" datavaluefield="SId" height="24px" openrefwidth="610" width="160px">
                    <columns>
                            <InfoLight:WebRefColumn ColumnName="SId" HeadText="物品编码" Width="60" />
                            <InfoLight:WebRefColumn ColumnName="SName" HeadText="名称" Width="100" />
                            <InfoLight:WebRefColumn ColumnName="SType" HeadText="类型" Width="50" />
                            <InfoLight:WebRefColumn ColumnName="TName" HeadText="类别" Width="100" />
                            <InfoLight:WebRefColumn ColumnName="Remark" HeadText="备注" Width="100" />
                        </columns>
                </infolight:webrefval>
            </td>
            <td style="width: 100px">
                <asp:Label ID="Label2" runat="server" Text="办公品分类："></asp:Label>
            </td>
            <td>
                <infolight:webdropdownlist id="WebDropDownList1" runat="server" appenddatabounditems="True"
                    autoinsertemptydata="True" datasourceid="wdsServices_SV_Supplies_SV_Type" datatextfield="TName"
                    datavaluefield="TId" driverobject="" filter="" filterobject="" onlyshowselecttext="False"
                    width="140px">
                </infolight:webdropdownlist>
            </td>
            <td  valign="middle" style="text-align: right;">
                <span class="roundbtn">
                    <asp:LinkButton ID="btnSearch" runat="server" Text="&nbsp;&nbsp;&nbsp;&nbsp;查 询&nbsp;&nbsp;&nbsp;&nbsp;" OnClick="btnSearch_Click"></asp:LinkButton>
                </span>&nbsp;&nbsp;&nbsp;&nbsp; <span class="roundbtn">
                    <asp:LinkButton ID="btnClear" runat="server" Text=" 清 除 条 件 " OnClick="btnClear_Click"></asp:LinkButton>
                </span>&nbsp;&nbsp;&nbsp;&nbsp;
            </td>
        </tr>
    </table>
    </div>
    <infolight:webgridview id="wgvMaster" runat="server" allowpaging="False" cellpadding="5"
        forecolor="#333333" width="100%" aborticonurl="../Image/UIPics/Abort.gif" addiconurl="../Image/UIPics/Add.gif"
        applyiconurl="../Image/UIPics/Apply.gif" canceliconurl="../Image/UIPics/Cancel.gif"
        mouseoveraborticonurl="../Image/UIPics/Abort2.gif" mouseoveraddiconurl="../Image/UIPics/Add2.gif"
        mouseoverapplyiconurl="../Image/UIPics/Apply2.gif" mouseovercanceliconurl="../Image/UIPics/Cancel2.gif"
        mouseoverokiconurl="../Image/UIPics/OK2.gif" mouseoverqueryiconurl="../Image/UIPics/Query2.gif"
        okiconurl="../Image/UIPics/OK.gif" queryiconurl="../Image/UIPics/Query.gif" headerstylewrap="False"
        backcolor="White" bordercolor="White" borderstyle="Groove" borderwidth="2px">
        <pagersettings mode="NumericFirstLast" />
        <footerstyle backcolor="#507CD1" forecolor="White" font-bold="True"></footerstyle>
        <navcontrols>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/add2.gif" ControlText="add" ControlName="Add" ControlType="Image" ImageUrl="../image/uipics/add.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/ok2.gif" ControlText="Insert" ControlName="OK" ControlType="Image" ImageUrl="../image/uipics/ok.gif"></InfoLight:ControlItem>
<InfoLight:ControlItem ControlVisible="True" Size="25" MouseOverImageUrl="../image/uipics/cancel2.gif" ControlText="cancel" ControlName="Cancel" ControlType="Image" ImageUrl="../image/uipics/cancel.gif"></InfoLight:ControlItem>
</navcontrols>
        <columns>
                <asp:BoundField DataField="SId" HeaderText="编码" SortExpression="SId" />
                <asp:BoundField DataField="SName" HeaderText="名称" SortExpression="SName" />
                <asp:BoundField DataField="SType" HeaderText="型号" SortExpression="SType" />
                <asp:BoundField DataField="UName" HeaderText="单位" SortExpression="UName" />
                <asp:BoundField DataField="TName" HeaderText="分类" SortExpression="TName" />
                <asp:BoundField DataField="Remark" HeaderText="备注" SortExpression="Remark" />
                <asp:BoundField DataField="SSCount" HeaderText="库存数量" SortExpression="SSCount" />
                <asp:BoundField DataField="TypeId" HeaderText="分类编号" SortExpression="TypeId" Visible="False" />
</columns>
        <rowstyle backcolor="#EFF3FB"></rowstyle>
        <editrowstyle backcolor="#2461BF"></editrowstyle>
        <selectedrowstyle backcolor="#D1DDF1" forecolor="#333333" font-bold="True"></selectedrowstyle>
        <pagerstyle backcolor="LightBlue" forecolor="White" horizontalalign="Center"></pagerstyle>
        <headerstyle backcolor="DeepSkyBlue" forecolor="White" font-bold="True"></headerstyle>
        <alternatingrowstyle backcolor="White" bordercolor="White"></alternatingrowstyle>
    </infolight:webgridview>
</asp:Content>
